Description of combined_data.csv

The combined_data.csv combines data from 3 of the log files: user-session.csv, buy-clicks.csv, and game-clicks.csv. You may read a description of these log files in the Week 1 Reading: "Understanding the CSV files Generated by the Scripts" . The columns in combined_data.csv are as follows:

Column

Description

userid

User ID

userSessionid

User session ID

team_level

User’s team level

platformType

Platform used by user

count_gameclicks

Total number of game clicks for user session

count_hits

Total number of game hits for user session

count_buyid

Total number of purchases for user session

avg_price

Average purchase price for user session

You may also notice numerous NULL values. This results from records not actually having values for those particular variables because of how the aggregation was done.